Overview: Join Timestamps

Use this operation to merge two or more timestamp fields into one timestamp field, with all timestamps listed chronologically. The data values of other fields are still listed at their original timestamps, and can either be repeated for the additional timestamps in the joined timestamp field, or be interpolated to generate values for the additional timestamps.

This operation creates a new dataset, with new fields. These new fields contain both original data values as well as repeated or interpolated values corresponding to the additional timestamps. Original fields need to be mapped to the selected timestamp fields during configuration.

Properties

Category:	Transform
Performance risk:	High potential performance risk. The performance is influenced by the size of the text file being imported, which is determined by number of rows and/or the number of columns of the dataset.
Knowledge required:	Working knowledge of the software.

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	Yes
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	Yes
Does it modify the current dataset in any way?	No

Requirements

This operation needs a dataset with at least two timestamp fields to join, and another field that must be an integer, double or string field.

Results

A new dataset with a single, joined timestamp field.
Data in the other field will either be repeated or interpolated to create values at the new additional timestamps.